Vehicle Tracking System Architecture

Snowflake Database

Stores vehicle tracking data (trips, parking events)

SQL Query

Data Ingestion Layer

Connects to Snowflake, fetches data via SQL queries

Cleaned Data

Data Preprocessing Layer

Cleans data, extracts features (duration, mileage, time)

Feature Vectors

Machine Learning Layer

Applies KMeans clustering to identify patterns

Clustered Data

Visualization Layer

Generates HTML report with Recharts charts

HTML Report

Storage Layer

Saves HTML report locally or in Snowflake